sql 语句 验证身份证号码答:像这样写个视图就行了:create View eVMutiCard AS Select a.Badge,a.Name,a.DepID,a.Compid,a.JobID,a.Status,a.EmpType,a.ReportTo,b.Identification,N'身份证长度不合常理' As Remark From employee b Where (Len(b.Identification) Not In (15,18)And b.Identification Is Not Null...